
/****** Object:  Table [dbo].[deviceinfos]    Script Date: 2010-3-15 23:28:37 ******/
CREATE TABLE [dbo].[deviceinfos] (
	[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
	[ip] [varchar] (50) NULL ,
	[rcommunity] [varchar] (50) NULL ,
	[wcommunity] [varchar] (50) NULL ,
	[version] [int] NULL ,
	[descri] [varchar] (1000) NULL ,
	[name] [varchar] (50) NULL ,
	[port] [int] NULL ,
	[dtype] [int] NULL ,
	[product_desc] [varchar] (300) NULL ,
	[device_id] [varchar] (50) NULL ,
	[sysUptime] [varchar] (50) NULL ,
	[product_id] [varchar] (50) NULL ,
	[location] [varchar] (50) NULL ,
	[sysService] [varchar] (50) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[events]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[events] (
	[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
	[infotype] [varchar] (50) NULL ,
	[datetimes] [bigint] NULL ,
	[ip] [varchar] (50) NULL ,
	[port] [int] NULL ,
	[eventtype] [varchar] (50) NULL ,
	[eventid] [int] NULL ,
	[content] [varchar] (512) NULL ,
	[timestamps] [varchar] (50) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[hostresourceinfos]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[hostresourceinfos] (
	[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
	[hostid] [decimal](18, 0) NOT NULL ,
	[host] [varchar] (50) NULL ,
	[hrindex] [int] NULL ,
	[hrDescri] [varchar] (50) NULL ,
	[hrType] [varchar] (50) NULL ,
	[hrSize] [decimal](18, 0) NULL ,
	[ismonitor] [varchar] (1) NULL ,
	[hivalue] [float] NULL ,
	[lowvalue] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[hoststoragedatas]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[hoststoragedatas] (
	[hostid] [decimal](18, 0) NULL ,
	[ifIndex] [int] NULL ,
	[times] [decimal](18, 0) NULL ,
	[hrAllocation] [int] NULL ,
	[hrFail] [int] NULL ,
	[hrSize] [decimal](18, 0) NULL ,
	[hrUsed] [decimal](18, 0) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[interfacedatas]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[interfacedatas] (
	[hostid] [decimal](18, 0) NULL ,
	[ifindex] [bigint] NULL ,
	[times] [bigint] NULL ,
	[ifInOctets] [bigint] NULL ,
	[ifOutOctets] [bigint] NULL ,
	[ifInUcastPkts] [bigint] NULL ,
	[ifInNUcastPkts] [bigint] NULL ,
	[ifOutUcastPkts] [bigint] NULL ,
	[ifOutNUcastPkts] [bigint] NULL ,
	[ifInErrors] [bigint] NULL ,
	[ifOutErrors] [bigint] NULL ,
	[ifInDiscards] [bigint] NULL ,
	[ifOutDiscards] [bigint] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[interfaceinfos]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[interfaceinfos] (
	[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
	[hostid] [decimal](18, 0) NULL ,
	[host] [varchar] (50) NULL ,
	[ifindex] [int] NULL ,
	[iftype] [int] NULL ,
	[ifspeed] [bigint] NULL ,
	[ifdescri] [varchar] (8000) NULL ,
	[ifadminstatus] [int] NULL ,
	[ifoperstatus] [int] NULL ,
	[ismonitor] [varchar] (1) NULL ,
	[hivalue] [float] NULL ,
	[lowvalue] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[plans]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[plans] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[ip] [varchar] (50) NULL ,
	[name] [varchar] (50) NULL ,
	[deviceid] [decimal](18, 0) NULL ,
	[status] [int] NULL ,
	[begintime] [numeric](18, 0) NULL ,
	[repeater] [int] NULL ,
	[cname] [varchar] (50) NOT NULL ,
	[mailalerted] [tinyint] NULL ,
	[tomail] [varchar] (50) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[tbl_limits]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[tbl_limits] (
	[id] [bigint] NULL ,
	[index] [int] NULL ,
	[hivalue] [float] NULL ,
	[lowvalue] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[tbl_oid]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[tbl_oid] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[value] [varchar] (50) NULL ,
	[caption] [varchar] (50) NULL ,
	[name] [varchar] (50) NULL ,
	[typename] [varchar] (50) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[users]    Script Date: 2010-3-15 23:28:38 ******/
CREATE TABLE [dbo].[users] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Username] [nvarchar] (50) NULL ,
	[role] [nvarchar] (50) NULL ,
	[Password] [nvarchar] (50) NULL ,
	[Iflogin] [nvarchar] (50) NULL ,
	[Perstr] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
